package com.lxmes.gs.domain;

import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.baomidou.mybatisplus.annotation.*;
import com.lxmes.common.annotation.Excel;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

/**
 * 项目人员对象 gs_project_staff
 *
 * @author wdf
 * @date 2023-04-24
 */
@Data
@TableName("gs_project_staff")
public class ProjectStaff{
    private static final long serialVersionUID = 1L;

    /** 序号 */
    @TableId(type = IdType.AUTO)
    private Long id;

    /** 姓名 */
    @TableField(value = "name",condition = SqlCondition.LIKE)
    private String name;

    /** 英文名 */
    @TableField(value = "english_name",condition = SqlCondition.LIKE)
    private String englishName;

    /** 工号 */
    @TableField(value = "employee_id",condition = SqlCondition.LIKE)
    private String employeeId;

    /** 人员类别 */
    @TableField(value = "staff_category")
    private String staffCategory;

    /** 人员类型 */
    @TableField(value = "staff_type")
    private String staffType;

    /** 人员状态 */
    @TableField(value = "staff_status")
    private String staffStatus;

    /** 专家级别 */
    @TableField(value = "expert_level")
    private String expertLevel;

    /** 专家类别 */
    @TableField(value = "expert_category")
    private String expertCategory;

    /** 电话 */
    @TableField(value = "phone",condition = SqlCondition.LIKE)
    private String phone;

    /** 邮箱 */
    @TableField(value = "email")
    private String email;

    /** 年龄 */
    @TableField(value = "age")
    private Long age;

    /** 性别 */
    @TableField(value = "gender")
    private String gender;

    /** 民族 */
    @TableField(value = "ethnicity")
    private String ethnicity;

    /** 职务 */
    @TableField(value = "position")
    private String position;

    /** 职称 */
    @TableField(value = "professional_title")
    private String professionalTitle;

    /** 学位 */
    @TableField(value = "degree")
    private String degree;

    /** 学历 */
    @TableField(value = "education")
    private String education;

    /** 学科方向 */
    @TableField(value = "subject")
    private String subject;

    /** 学术专长 */
    @TableField(value = "academic_expertise")
    private String academicExpertise;

    /** 承担项目 */
    @TableField(value = "undertaken_projects")
    private String undertakenProjects;

    /** 科技成果 */
    @TableField(value = "technological_achievements")
    private String technologicalAchievements;

    /** 专家贡献 */
    @TableField(value = "expert_contribution")
    private String expertContribution;

    /** 参与项目 */
    @TableField(value = "participated_projects")
    private String participatedProjects;

    /** 获奖情况 */
    @TableField(value = "awards")
    private String awards;

    /** 评审项目 */
    @TableField(value = "reviewed_projects")
    private String reviewedProjects;

    /** 评审意见 */
    @TableField(value = "review_opinions")
    private String reviewOpinions;

    /** 政治面貌 */
    @TableField(value = "political_status")
    private String politicalStatus;

    /** 籍贯 */
    @TableField(value = "native_place")
    private String nativePlace;

    /** 出生年月 */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @TableField(value = "birthday")
    private Date birthday;

    /** 身份证号码 */
    @TableField(value = "id_card_number",condition = SqlCondition.LIKE)
    private String idCardNumber;

    /** 入职时间 */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @TableField(value = "entry_date")
    private Date entryDate;

    /** 集团代码 */
    @TableField(value = "group_code")
    private String groupCode;

    /** 集团名称 */
    @TableField(value = "group_name",condition = SqlCondition.LIKE)
    private String groupName;

    /** 公司代码 */
    @TableField(value = "factory_code")
    private String factoryCode;

    /** 公司名称 */
    @TableField(value = "factory_name",condition = SqlCondition.LIKE)
    private String factoryName;

    /** 部门（车间）代码 */
    @TableField(value = "department_code")
    private String departmentCode;

    /** 部门（车间）名称 */
    @TableField(value = "department_name",condition = SqlCondition.LIKE)
    private String departmentName;

    /** 科研团队类型 */
    @TableField(value = "research_team_type")
    private String researchTeamType;

    /** 科研团队代码 */
    @TableField(value = "research_team_code")
    private String researchTeamCode;

    /** 科研团队名称 */
    @TableField(value = "research_team_name",condition = SqlCondition.LIKE)
    private String researchTeamName;

    /** 创建人 */
    @TableField(value = "create_by")
    private String createBy;

    /** 创建日期 */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @TableField(value = "create_time")
    private Date createTime;

    /** 修改人 */
    @TableField(value = "update_by")
    private String updateBy;

    /** 修改日期 */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @TableField(value = "update_time")
    private Date updateTime;

    /** 备注 */
    @TableField(value = "remark")
    private String remark;


}
